
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spConPointsGetBySupplier]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spConPointsGetBySupplier]
GO

CREATE PROCEDURE spConPointsGetBySupplier
	@SupplierNo nvarchar(3)
AS

SELECT
	[ConPointID]
FROM
	Suppliers
WHERE
		[SupplierCode] = @SupplierNo

GO
	

	
 